Tabela GPSubscription

Definicja tabeli GPSubscription

Name

GPSubscription

Code

GPSubscription

Comment

 


Lista kolumn tabeli GPSubscription

Name

Code

GPSubscriptionID

GPSubscriptionID

GPSubscriptionTypeID

GPSubscriptionTypeID

ExternalOrgUnitID

ExternalOrgUnitID

ExternalDoctorID

ExternalDoctorID

CategoryGPID

CategoryGPID

PupilCategoryID

PupilCategoryID

SchoolID

SchoolID

IdentificationTypeID

IdentificationTypeID

GPSubscriptionStatusID

GPSubscriptionStatusID

PersonID

PersonID

Per_PersonID

Per_PersonID

StartDT

StartDT

StopDT

StopDT

Comments

Comments

Active

Active

IsMilitaryServicePlace

IsMilitaryServicePlace

IsBaseOfPayment

IsBaseOfPayment

IdentificationDocumentNo

IdentificationDocumentNo

FluoridePrevention

FluoridePrevention

Version

Version

ProblemsDesc

ProblemsDesc

ServiceRangeCode

ServiceRangeCode

DistinguishingMark

DistinguishingMark

ServCode

ServCode

InsertDate

InsertDate

InsertingPerson

InsertingPerson

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson

ClassNo

ClassNo

ChoiceNo

ChoiceNo

GPSubscriptionProblemID

GPSubscriptionProblemID


Kolumna GPSubscriptionID tabeli GPSubscription

Definicja kolumny GPSubscriptionID tabeli GPSubscription

Name

GPSubscriptionID

Code

GPSubscriptionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna GPSubscriptionTypeID tabeli GPSubscription

Definicja kolumny GPSubscriptionTypeID tabeli GPSubscription

Name

GPSubscriptionTypeID

Code

GPSubscriptionTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExternalOrgUnitID tabeli GPSubscription

Definicja kolumny ExternalOrgUnitID tabeli GPSubscription

Name

ExternalOrgUnitID

Code

ExternalOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExternalDoctorID tabeli GPSubscription

Definicja kolumny ExternalDoctorID tabeli GPSubscription

Name

ExternalDoctorID

Code

ExternalDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CategoryGPID tabeli GPSubscription

Definicja kolumny CategoryGPID tabeli GPSubscription

Name

CategoryGPID

Code

CategoryGPID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PupilCategoryID tabeli GPSubscription

Definicja kolumny PupilCategoryID tabeli GPSubscription

Name

PupilCategoryID

Code

PupilCategoryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SchoolID tabeli GPSubscription

Definicja kolumny SchoolID tabeli GPSubscription

Name

SchoolID

Code

SchoolID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IdentificationTypeID tabeli GPSubscription

Definicja kolumny IdentificationTypeID tabeli GPSubscription

Name

IdentificationTypeID

Code

IdentificationTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna GPSubscriptionStatusID tabeli GPSubscription

Definicja kolumny GPSubscriptionStatusID tabeli GPSubscription

Name

GPSubscriptionStatusID

Code

GPSubscriptionStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli GPSubscription

Definicja kolumny PersonID tabeli GPSubscription

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Per_PersonID tabeli GPSubscription

Definicja kolumny Per_PersonID tabeli GPSubscription

Name

Per_PersonID

Code

Per_PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID pacjenta


Kolumna StartDT tabeli GPSubscription

Definicja kolumny StartDT tabeli GPSubscription

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli GPSubscription

Definicja kolumny StopDT tabeli GPSubscription

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Comments tabeli GPSubscription

Definicja kolumny Comments tabeli GPSubscription

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Active tabeli GPSubscription

Definicja kolumny Active tabeli GPSubscription

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna IsMilitaryServicePlace tabeli GPSubscription

Definicja kolumny IsMilitaryServicePlace tabeli GPSubscription

Name

IsMilitaryServicePlace

Code

IsMilitaryServicePlace

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna IsBaseOfPayment tabeli GPSubscription

Definicja kolumny IsBaseOfPayment tabeli GPSubscription

Name

IsBaseOfPayment

Code

IsBaseOfPayment

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna IdentificationDocumentNo tabeli GPSubscription

Definicja kolumny IdentificationDocumentNo tabeli GPSubscription

Name

IdentificationDocumentNo

Code

IdentificationDocumentNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna FluoridePrevention tabeli GPSubscription

Definicja kolumny FluoridePrevention tabeli GPSubscription

Name

FluoridePrevention

Code

FluoridePrevention

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Version tabeli GPSubscription

Definicja kolumny Version tabeli GPSubscription

Name

Version

Code

Version

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ProblemsDesc tabeli GPSubscription

Definicja kolumny ProblemsDesc tabeli GPSubscription

Name

ProblemsDesc

Code

ProblemsDesc

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna ServiceRangeCode tabeli GPSubscription

Definicja kolumny ServiceRangeCode tabeli GPSubscription

Name

ServiceRangeCode

Code

ServiceRangeCode

Data Type

VARCHAR2(14)

Mandatory

No

Comment

Ustalony przez platnika kod zakresu swiadczen ze slownika platnika. (Zakres swiadczen- dawniej nazywany 'produktem kontraktowym' ustalany przez platnika na podstawie przekazanych danych deklaracji (tzw.czynników stawki))


Kolumna DistinguishingMark tabeli GPSubscription

Definicja kolumny DistinguishingMark tabeli GPSubscription

Name

DistinguishingMark

Code

DistinguishingMark

Data Type

NUMBER(10)

Mandatory

No

Comment

Wyróznik (wariant) zakresu swiadczen. (Wystepuje tylko wtedy, gdy zakres swiadczen posiada zdefiniowane wyrózniki)


Kolumna ServCode tabeli GPSubscription

Definicja kolumny ServCode tabeli GPSubscription

Name

ServCode

Code

ServCode

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Kod swiadczenia z katalogu platnika. (swiadczenie z katalogu platnika dawniej bylo nazywane 'produktem jednostkowym')


Kolumna InsertDate tabeli GPSubscription

Definicja kolumny InsertDate tabeli GPSubscription

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna InsertingPerson tabeli GPSubscription

Definicja kolumny InsertingPerson tabeli GPSubscription

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna LastModifiedDT tabeli GPSubscription

Definicja kolumny LastModifiedDT tabeli GPSubscription

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli GPSubscription

Definicja kolumny LastModifiedPerson tabeli GPSubscription

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ClassNo tabeli GPSubscription

Definicja kolumny ClassNo tabeli GPSubscription

Name

ClassNo

Code

ClassNo

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna ChoiceNo tabeli GPSubscription

Definicja kolumny ChoiceNo tabeli GPSubscription

Name

ChoiceNo

Code

ChoiceNo

Data Type

NUMBER(5)

Mandatory

No

Comment

Informuje którego dokonano wyboru w biezacym roku:
1 - dla wyboru pierwszorazowego
2 - dla wyboru drugorazowego
999 - dla wyboru kolejnego


Kolumna GPSubscriptionProblemID tabeli GPSubscription

Definicja kolumny GPSubscriptionProblemID tabeli GPSubscription

Name

GPSubscriptionProblemID

Code

GPSubscriptionProblemID

Data Type

NUMBER(10)

Mandatory

No

Comment

kolumna wskazuje na wartosc ze slownika z kodami bledów (DictionaryValueID z DictionaryValue)


Lista kluczy tabeli GPSubscription

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli GPSubscription

Definicja klucza Identifier_1 tabeli GPSubscription

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment